Projects in Supply Chain Management

Power BI reports for a global Pharmaceutical company
Helped the client monitor the timeliness and completeness of product deliveries at a global scale, working with their Customer Analytics CoE, to implement OTIF related BI reports.

  • Redesigned the On-Time & Fill-Rate report calculations to accommodate different delivery dates, enhancing accuracy and flexibility in performance tracking.
  • Defined development specifications for Power BI and provided team guidance on DAX best practices, ensuring high-quality and efficient reporting as per client requirements.
  • Led the refactoring of Power BI and Snowflake models to address challenges posed by increased data volume, resulting in a 2.25x improvement in performance and a 2.15x reduction in capacity costs.

Power BI reports for a global Shipping Company
Matt helped the company manage the ship spares supply chain of various shipping companies globally, by designing & developing a set of Power BI reports with advanced UI features and row-level security to provide personalized information on shipments, costs, and ESG metrics. These tools enabled the client to convert raw data into insights, KPIs & market trends and had a profound impact on their business; as they allowed them to operate with emphasis on strategic adjustments and aim to higher efficiency, sustainability and cost savings.

3PL report sanitized 3PL report sanitized 3PL report sanitized

** The screenshots have been 'sanitized'(parts of the reports with sensitive information have been removed) and aproval for publication has been granted.

Power BI reporting pack for a Greek manufacturing company
Implemented a set of Power BI reports to help the client monitor their global sales, shipments & production, and manage their safety stock levels, leveraging SAP BW & Proteus WMS data and incorporating Aimplan, for the users to provide detailed input and create custom scenarions for lead times and market demand.

  • Designed a robust dimensional data model to support scalable, high-performance analytics tailored to supply chain and inventory planning use cases.
  • Created reporting tables and interactive Power BI visuals to provide historic insights & future trends on sales, production, and inventory KPIs.
  • Integrated Aimplan visuals within the reports, enabling user input through Power BI tables and custom extensions, which fed directly into safety stock and reorder point calculations.

Logistics Report Demo


Guidance on how to use the report Οδηγίες χρήσης της αναφοράς στα ελληνικά